* Generate plot for Pedersen Index 
version 13.1
clear all
* Read data
import excel pedersen-ost-west-1990-2013.xls, cellrange(c22:o22)
* Transpose (years -> rows)
xpose, clear

* drop empty cells
drop if v1==.

* rename
ren v1 index

* define var to hold year
gen BTW = 1990 in 1
replace BTW = 1990 + (_n -1) * 4 in 2/4
replace BTW = 2005 in 5
replace BTW = 2005 + (_n -5) * 4 in 6/7


* generate graph & export
set scheme tufte
lab var index "Ost-West-Differenz"
graph twoway (line index BTW) (scatter index BTW), legend(off)
graph export ost-west-pedersen-verlauf-1990-2013.eps, replace






